CREATE PROCEDURE [dbo].[asi_UpdatePublishRequest]
    @PublishRequestKey uniqueidentifier,
    @PublishedDateTime datetime
AS
BEGIN

    SET NOCOUNT ON;
    DECLARE @PendingCount int
    DECLARE @ErrorCount int

    SELECT @PendingCount = Count(*) FROM PublishRequestDetail
    WHERE PublishRequestStatusCode = 0
      AND PublishRequestKey = @PublishRequestKey
    SELECT * FROM PublishRequestDetail
    WHERE PublishRequestStatusCode = 0
      AND PublishRequestKey = @PublishRequestKey

    SELECT @ErrorCount = Count(*) FROM PublishRequestDetail
    WHERE PublishRequestStatusCode = 3
      AND PublishRequestKey = @PublishRequestKey

    if (@PendingCount = 0)
    BEGIN
        UPDATE PublishRequest
           SET PublishedDateTime = @PublishedDateTime
         WHERE PublishRequestKey = @PublishRequestKey

        IF (@ErrorCount = 0)
        BEGIN
            UPDATE PublishMessageLog
               SET DisplayFlag = 0
             WHERE PublishRequestKey = @PublishRequestKey
        END
    END
END


SET ANSI_NULLS ON

GO